Tabela Beds

Definicja tabeli Beds

Name

Beds

Code

Beds

Comment

 


Lista kolumn tabeli Beds

Name

Code

BedsID

BedsID

BedsTypeID

BedsTypeID

Maximum

Maximum

Closed

Closed

Reserved

Reserved

StartDT

StartDT

StopDT

StopDT

InsertDate

InsertDate

Active

Active

InsertingPerson

InsertingPerson

LastModifiedDT

LastModifiedDT

LastModifiedPerson

LastModifiedPerson


Kolumna BedsID tabeli Beds

Definicja kolumny BedsID tabeli Beds

Name

BedsID

Code

BedsID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna BedsTypeID tabeli Beds

Definicja kolumny BedsTypeID tabeli Beds

Name

BedsTypeID

Code

BedsTypeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna Maximum tabeli Beds

Definicja kolumny Maximum tabeli Beds

Name

Maximum

Code

Maximum

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Closed tabeli Beds

Definicja kolumny Closed tabeli Beds

Name

Closed

Code

Closed

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Reserved tabeli Beds

Definicja kolumny Reserved tabeli Beds

Name

Reserved

Code

Reserved

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna StartDT tabeli Beds

Definicja kolumny StartDT tabeli Beds

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

PL: Data poczatku
EN: Start date
DE: das Beginndatum


Kolumna StopDT tabeli Beds

Definicja kolumny StopDT tabeli Beds

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

PL: Data koncowa
EN: Stop date
DE: Das Endedatum


Kolumna InsertDate tabeli Beds

Definicja kolumny InsertDate tabeli Beds

Name

InsertDate

Code

InsertDate

Data Type

DATE

Mandatory

No

Comment

PL: Data wstawienia rekordu
EN: Insert date of record
DE: Das Date der Ansatzstelle fur den Rekord


Kolumna Active tabeli Beds

Definicja kolumny Active tabeli Beds

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

No

Comment

PL: Aktywnosc wiersza.
EN: Record's Activity
DE: Aktivitat des Rekord


Kolumna InsertingPerson tabeli Beds

Definicja kolumny InsertingPerson tabeli Beds

Name

InsertingPerson

Code

InsertingPerson

Data Type

NUMBER(10)

Mandatory

No

Comment

PL: Osoba wstawiajaca rekord
EN: Person inserting record


Kolumna LastModifiedDT tabeli Beds

Definicja kolumny LastModifiedDT tabeli Beds

Name

LastModifiedDT

Code

LastModifiedDT

Data Type

DATE

Mandatory

No

Comment

Data ostatniej modyfikacji


Kolumna LastModifiedPerson tabeli Beds

Definicja kolumny LastModifiedPerson tabeli Beds

Name

LastModifiedPerson

Code

LastModifiedPerson

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Lista kluczy tabeli Beds

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli Beds

Definicja klucza Identifier_1 tabeli Beds

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment